Tracking user record access
AudBase automatically keeps track of basic record modification activity within the database, showing which user has changed a record, and when. The results are stored in a field called Record Modification History that appears in every table. The Record Access item on the Preferences form allows the administrator to have a separate log file created that will not only show that records have been changed, but also which individual fields were modified and by whom, and even who has looked at what records.
The administrator can choose what kind of information to save to the log file using this item. The choices, and the types of log files they create, are:
To log individual field modifications, you must first check Record modifications. This is because a file showing all changes to all fields must include the entire record that those fields are part of.
When one of these options is selected, AudBase creates a text file in the same folder where the program's data files are saved, and names it with your version of AudBase plus "Log.TXT."